Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$RSRC_CONSUMER_GROUP

This view displays data related to currently active resource consumer groups.

Column | Datatype | Description
--- | --- | ---
`ID` | `NUMBER` | The consumer group object ID. A unique number, consistent across database shutdowns and startups.
`NAME` | `VARCHAR2(32)` | Name of the consumer group
`ACTIVE_SESSIONS` | `NUMBER` | Number of currently active sessions in the consumer group
`EXECUTION_WAITERS` | `NUMBER` | Number of currently active sessions waiting for an execution time slice in which they will be able to use CPU.
`REQUESTS` | `NUMBER` | Cumulative number of requests that were executed in the consumer group
`CPU_WAIT_TIME` | `NUMBER` | Cumulative amount of time that sessions waited for CPU
`CPU_WAITS` | `NUMBER` | Cumulative number of times all sessions in the consumer group had to wait for CPU
`CONSUMED_CPU_TIME` | `NUMBER` | Cumulative amount of CPU time consumed by all sessions in the consumer group
`YIELDS` | `NUMBER` | Cumulative number of times that sessions in the consumer group had to yield CPU to other sessions because of quantum expiration
`QUEUE_LENGTH` | `NUMBER` | Number of sessions waiting in the queue
`CURRENT_UNDO_CONSUMPTION` | `NUMBER` | Current amount (in kilobytes) of undo consumed by the consumer group
`ACTIVE_SESSION_LIMIT_HIT` | `NUMBER` | Number of times that sessions in the consumer group were queued because the consumer group reached its active session limit
`UNDO_LIMIT_HIT` | `NUMBER` | Number of times that queries in the consumer group were cancelled because the consumer group reached its `UNDO_POOL` limit
`SESSION_SWITCHES_IN` | `NUMBER` | Number of times that sessions switched into the consumer group. This does not include the number of times a session started in the consumer group (this is displayed by the `REQUESTS` column).
`SESSION_SWITCHES_OUT` | `NUMBER` | Number of times that sessions switched out of the consumer group to a different consumer group
`SQL_CANCELED` | `NUMBER` | Number of times that SQL queries running in the consumer group were aborted because they exceeded the resource manager plan's `SWITCH_TIME` limit and `CANCEL_SQL` was specified as the resource manager plan's `SWITCH_GROUP`
`ACTIVE_SESSIONS_KILLED` | `NUMBER` | Number of times that sessions running in the consumer group were terminated because they exceeded the resource manager plan's `SWITCH_TIME` limit and `KILL_SESSION` was specified as the resource manager plan's `SWITCH_GROUP`
`IDLE_SESSIONS_KILLED` | `NUMBER` | Number of times that sessions in the consumer group were killed because they were idle for too long (reached `MAX_IDLE_TIME`)
`IDLE_BLKR_SESSIONS_KILLED` | `NUMBER` | Number of times that sessions in the consumer group were killed because they were idle too long (reached `MAX_IDLE_BLOCKER_TIME`) and were blocking other sessions
`QUEUED_TIME` | `NUMBER` | Total amount of time that sessions in the consumer group have spent in the QUEUED state because of the active session limit
`QUEUE_TIME_OUTS` | `NUMBER` | Number of times that requests from sessions in the consumer group timed out because they were queued for too long (reached `QUEUEING_P1`)

See Also: Oracle Database Administrator's Guide for information on resource groups Oracle Database PL/SQL Packages and Types Reference for information on creating resource groups with the `DBMS_RESOURCE_MANAGER` package